Teaching spreadsheet development using peer audit and self-audit methods for reducing error
نویسندگان
چکیده
Recent research has highlighted the high incidence of errors in spreadsheet models used in industry. In an attempt to reduce the incidence of such errors, a teaching approach has been devised which aids students to reduce their likelihood of making common errors during development. The approach comprises of spreadsheet checking methods based on the commonly accepted educational paradigms of peer assessment and self-assessment. However, these paradigms are here based upon practical techniques commonly used by the internal audit function such as peer audit and control and risk self-assessment. The result of this symbiosis between educational assessment and professional audit is a method that educates students in a set of structured, transferable skills for spreadsheet error-checking which are useful for increasing error-awareness in the classroom and for reducing business risk in the workplace.
منابع مشابه
A survey of the mediating role of self-efficacy on the relationship between audit quality and professional development in the public sector
What society expects the audit profession is delivering audit quality services. The quality that determines audit performance depends on several factors such as auditor capabilities and professional performance of the auditor. The aim of this study was to investigate the mediating role of self-efficacy on the relationship between audit quality and professional development in the public sector. ...
متن کاملA Typical Model Audit Approach: Spreadsheet Audit Methodologies in the City of London
Spreadsheet audit and review procedures are an essential part of almost all City of London financial transactions. Structured processes are used to discover errors in large financial spreadsheets underpinning major transactions of all types. Serious errors are routinely found and are fed back to model development teams generally under conditions of extreme time urgency. Corrected models form th...
متن کاملRisk Assessment For Spreadsheet Developments: Choosing Which Models to Audit
Errors in spreadsheet applications and models are alarmingly common (some authorities, with justification cite spreadsheets containing errors as the norm rather than the exception). Faced with this body of evidence, the auditor can be faced with a huge task the temptation may be to launch code inspections for every spreadsheet in an organisation. This can be very expensive and time-consuming. T...
متن کاملMitigating Spreadsheet Model Risk with Python Open Source Infrastructure
Across an aggregation of EuSpRIG presentation papers, two maxims hold true: spreadsheets models are akin to software, yet spreadsheet developers are not software engineers. As such, the lack of traditional software engineering tools and protocols invites a higher rate of error in the end result. This paper lays ground work for spreadsheet modelling professionals to develop reproducible audit to...
متن کاملPresenting a Model for Social Responsibility of Audit Firms Using Grounded Theory Method
This study was aimed to present a model for social responsibility of audit firms using the grounded theory method. To this end, the components and dimensions of social responsibility model of audit firms were identified and explained. The research method was applied in terms of purpose, mixed (qualitative-quantitative)exploratoryin termsof datatype, anddescriptive-correlationalinterms of data c...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
- CoRR
دوره abs/0801.1514 شماره
صفحات -
تاریخ انتشار 2004